<?php
if(!defined('IN_IBEIKE')) {
	exit('Access Denied');
}

class table_common_cron extends common_table
{
	public function __construct() {

		$this->_table = 'common_cron';
		$this->_pk    = 'cronid';

		parent::__construct();
	}

	public function fetch_nextrun($timestamp) {
		$timestamp = intval($timestamp);
		return DB::fetch_first('SELECT * FROM '.DB::table($this->_table)."	WHERE available>'0' AND nextrun<='$timestamp' ORDER BY nextrun LIMIT 1");
	}

	public function fetch_nextcron() {
		return DB::fetch_first('SELECT * FROM '.DB::table($this->_table)."	WHERE available>'0' ORDER BY nextrun LIMIT 1");
	}
	public function fetch_all_by_cronid($cronid){
		if(!empty($cronid)&&$cronid){
			return DB::fetch_all('SELECT * FROM %t WHERE cronid=%s',array($this->_table,$cronid));//返回数组包含各个字段的值
		}
		return false;
	}


}

?>